Click here to open LunaNotes

LunaNotes

Paris 2024 Olympics Dashboard Project in PowerBI with Python | The Developer

15.1K subscribers

5,023 views Aug 14, 2024 #powerbitutorialforbeginners #powerbitutorial #parisolympics2024

Get ready to dive into the world of data analytics with a special focus on the Paris 2024 Olympics! 🏅 In this tutorial, we'll guide you through the process of creating a dynamic and visually stunning Power BI dashboard that captures the excitement and data of the Olympic Games. Download from here: https://thedeveloperyt.com/product/ol... 📂Data Source Folder Link- https://drive.google.com/drive/folder... 📚Blogs: How to install Python: https://thedeveloperyt.com/install-py... How to Setup Kaggle with Python https://thedeveloperyt.com/how-to-set... How to Import Olympic Data using Python https://thedeveloperyt.com/olympic-da... 📑Datatset Credit: Name:Petro Dataset Name: Paris 2024 Olympic Summer Games Link:https://www.kaggle.com/datasets/piter... Using a combination of Python, Kaggle datasets, Figma, and other powerful tools, you'll learn how to gather, process, and visualize Olympic data in a way that’s both informative and engaging. Whether you're a data enthusiast, a sports analyst, or a Power BI professional, this project will equip you with the skills to analyze large datasets and present insights that matter. What You Will Learn: Data Extraction with Python: Learn how to use Python to extract and clean data from Kaggle's comprehensive datasets on the Olympics. We'll walk you through the entire process, from accessing the data to preparing it for analysis in Power BI. Designing the Dashboard in Figma: Discover how to design a professional and user-friendly dashboard interface using Figma. We'll cover layout planning, color schemes, and best practices for creating a visually appealing design that enhances the user experience. Building the Dashboard in Power BI: With the data prepared and the design in place, you'll move on to building the dashboard in Power BI. Learn how to create interactive visualizations that track medal counts, athlete performance, event schedules, and more. Advanced Power BI Features: Explore advanced Power BI functionalities, including DAX for complex calculations, Power Query for data transformation, and custom visuals to make your dashboard stand out. Key Topics Covered: Olympic Data Analysis: Understand how to analyze large datasets related to the Paris 2024 Olympics, including athlete statistics, country performance, and historical comparisons. Python Data Processing: Use Python to automate data extraction, cleaning, and preparation for your Power BI dashboard. Figma for Dashboard Design: Master the basics of Figma to create a sleek and modern dashboard design that enhances user interaction. Interactive Visualizations: Create engaging visualizations in Power BI that allow users to explore Olympic data from different angles. Real-Time Data Updates: Learn how to set up your dashboard to automatically update with new data, ensuring that it remains relevant throughout the Olympics. Who Should Watch: Data Analysts & BI Professionals: Take your Power BI skills to the next level by learning how to integrate Python and Figma into your projects. Sports Analysts & Enthusiasts: Get insights into Olympic performance and trends with a customized dashboard tailored to your needs. Students & Beginners: This tutorial is perfect for anyone looking to start their journey into data analytics with a fun and relevant project. Developers: Learn how to combine multiple tools and technologies to create a comprehensive data analysis solution. Why Watch This Video? The Paris 2024 Olympics present a unique opportunity to work with real-world, large-scale data. By the end of this tutorial, you'll have the skills to create a Power BI dashboard that not only looks great but also provides valuable insights into one of the most watched events in the world. Whether you’re preparing for a career in data analytics or just looking to expand your skillset, this project is an excellent way to showcase your abilities. Timestamps: 00:00:00 : Intro 00:06:18 : Python Script with Kaggle 00:18:10 : Power Query:Setup Tables 00:23:53 : Overview Page :DAX,Filters,Visualization 01:01:09 : Figma Background Creation 01:05:15 : Add Colors,Images,Icons 01:26:18 : Athelets Page 01:52:30 : Country Page 01:59:45 : Historical Page Related Keywords: Power BI dashboard Paris 2024 Olympics Python data analysis Kaggle datasets Figma design for dashboards Sports analytics Power BI and Python integration Real-time data in Power BI Advanced Power BI techniques Olympic Games data analysis 🌍Social Media :- Instagram : •

/ thedevelpoer.yt Linkdin : •

/ the-developer-407024292 Telegram : • https://www.t.me/thedeveloperyt #powerbi #olympics #parisolympics2024 #python #figma #olympic #powerbitutorialforbeginners #powerbitutorial #powerbidashboarddesign #powerbiproject #powerbitraining#powerbiandpowerquery

Intro

Python Script with Kaggle

Power Query:Setup Tables

Overview Page :DAX,Filters,Visualization

Figma Background Creation

Add Colors,Images,Icons

Athelets Page

Country Page

Underground Academy

Hanu Dixit

Underground Academy

Transcript

Follow along using the transcript.

The Developer

15.1K subscribers

Show less

81 Comments

Add a comment...

Pinned by The Developer

@The-Developer-BI

2 days ago (edited)

Challenge for you

https://youtube.com/shorts/6NIIa-VdSJk?si=Ypv3_CxvjMCpbDI2

@user-ej5pc8zf5h

1 hour ago

i like

@datax_official

2 hours ago

I will must say you're on another level of dashboards skills. Tapori style teaching like Rohit Sharma

·

@rutvik8556

3 hours ago

the data in medals section is only having 760 cells when i imported it using python script.

@ibrahimabdallah5969

10 hours ago

When are you going to make this available in english?

@ZzZzZzZz.......

15 hours ago

Bhai khudse banane mai kitni waqt lag sakthi hai without figma excluding some features. Mai fresher hu aur resume mai dalna chahtha hu

Translate to English

·

@The-Developer-BI

15 hours ago (edited)

@ZzZzZzZz....... python skip krdo Dataset lekr CSV wala isse bnalo... May be weekend me ban jayega

Translate to English

@ZzZzZzZz.......

15 hours ago

@The-Developer-BI Thanks bhaiya. Pura hone ke baad phir aake thankyou bolunga

Translate to English

@mohitchhikara5936

16 hours ago

missing steps for all info table creation, I tried creating it using medalists table but getting 250 unmatching rows. how can I solve that

·

@The-Developer-BI

16 hours ago

Don't create it we'll not use in the upcoming part also I have blur that part. Bcz of confusion.

@DhikrullahiOlamilekan

18 hours ago

i am a member please i need this

@muneebaaslam7920

19 hours ago

At 22:14 in the video, could you please explain how ALL_Info table is created?

·

@The-Developer-BI

19 hours ago

@muneebaaslam7920 watch more video we'll not use that table

@muneebaaslam7920

18 hours ago

Thanks you so much sir

@SakshiYadav-q7s

19 hours ago

Can you please explain the advantages of using python script instead of directly using downloaded data.

·

@The-Developer-BI

19 hours ago

@SakshiYadav-q7s When I was creating the dashboard, the data was being updated daily, which required me to download it repeatedly. However, now that the Olympics are over, there's no such issue anymore. You can still download the data, but I mentioned that if you're in a situation where you need daily updates, you don't need to download the data daily. You can simply use this script. This way, whenever you refresh your dataset, it will automatically update. There's more to it as well.

@corentindero8977

10 minutes ago

@The-Developer-BI Thanks ! Also, if the dashboard is published on PBI service, does it require a daily push or is it automatically updated when setting up an automated data refresh for example ?

@anshuraj7584

21 hours ago

In map also i am not getting option to upload file. How to enable all these options bro.

·

@The-Developer-BI

21 hours ago

@anshuraj7584 choose custom option on shape map and upload the file

@anshuraj7584

21 hours ago (edited)

@The-Developer-BI Thank you so much bro. It worked. Please help me with this as well i struggling since last 2 hours to just format slicer. I am not getting layout option to select image link in slicer.

Show less

@anshuraj7584

21 hours ago

Hi, I am not getting layout option to select image link in slicer. Can anyone help me this is?

·

@The-Developer-BI

14 hours ago

Power bi version?

@anshuraj7584

4 hours ago

@The-Developer-BI Version: 2.131.1203.0 64-bit (July, 2024)

@activebhai

22 hours ago

This is awesome bro really amazing can you please let me know from where did you get the shape map visual?

@activebhai

22 hours ago

found it its under global -> preview thank you so much really helpful just subscribed you :)

@swaminathanm.g1740

23 hours ago (edited)

Amazing work. Whether the dataset is correct because according to the Wikipedia the total medal is 1044.

·

@The-Developer-BI

22 hours ago

@swaminathanm.g1740 unfortunately I am not the owner of the dataset

@listentomusic8160

23 hours ago

Subscribe, you deserve it

@listentomusic8160

23 hours ago

Make a course on power bi

·

@RishuKatiyar-tn6ss

1 day ago (edited)

Bhai Ap Power Bi pe ek course upload kr do na (for beginners to advance )

·

@The-Developer-BI

19 hours ago

Layege jld hi

️

Translate to English

@santoshwaghmare4081

1 day ago

Well done Bros!! It's fantastic to see you developing your design skills to create more enhanced user experience reports!

·

@krishnataparia6945

1 day ago

Sir data galat hai kaggle vala Bhahut mis information diya hua hai.

Translate to English

·

@The-Developer-BI

1 day ago

Kiya miss information hai?

Translate to English

@krishnataparia6945

22 hours ago

Sir India ke data me we have won 6 medal lekin yaha total 22 medals dekha raha hai . Jab mene kholke dekhna then player ke name misprint the and ek player ke kaye naam likhe hue hai Aur usa and all ke bhi total gold and total medal misplaced hai

Translate to English

@krishnataparia6945

22 hours ago

Ekbar excel sheet ko dekhiyega na

Translate to English

@mohitchhikara5936

17 hours ago (edited)

@krishnataparia6945 bhai vo medalists ki list, total 22 players h jinko medals mile h, total events 6 hi h jisme medals h.

Translate to English

@krishnataparia6945

16 hours ago

Sorry sorry bhai me hockey ke 11 player bhul hi Gaya tha

. Me vahi soch raha tha ki yeah 21 medal kaise hogaye

Translate to English

@krishnataparia6945

16 hours ago

@mohitchikkar5936 thank you dost

@himanshshakk3083

1 day ago

Bhai yaar you are Pro Plus of power bi

·

@The-Developer-BI

1 day ago

Aapke postive feedback give more motivation

️

Translate to English

@aabhasagrawal410

1 day ago

sir medallists code ka count medals total k sum k equal kyu nhi h boht zada diff h

·

@The-Developer-BI

1 day ago

To medalist se lelo aap

Translate to English

@aabhasagrawal410

1 day ago

@The-Developer-BI hn pr diff kyu ara h data glt h ky. aur sir tableau ka tut daala kro please vo mac m bhi chlta h

Translate to English

@navdeepbhatnagar188

1 day ago

bro you are on next level plz upload regularly

·

@Ady5000

1 day ago (edited)

can someone please tell , how to create All_info query at 22:10

·

@shreyasadyanthaya7517

1 day ago

Content growing better day by day! Great Videos.

·

@funofcricket_

1 day ago

Bro You Are Outstanding

·

@AnnuSharma-te6ly

1 day ago

amazingg videooo... i have seen twice .. can you let me know how can i add that images ? like flag

·

@The-Developer-BI

1 day ago

It's a web url of images which i have explained in many videos how you can make these images If you still have any confusion watch our previous video ( market Dashboard we have explained in Detail ) Btw thank you

️

Show less

@AnnuSharma-te6ly

17 hours ago

@The-Developer-BI yes i saw that and understood... thnkw so much .. plz make one project on sql also

@santiagoescobar22

1 day ago

Indians are getting our jobs

@JudahSolomon-g3u

1 day ago

Thanks very much for the Videos you make on PowerBi, but Please some of us don't understand Hindi, so I will love it if you're able to make the videos in English

·

@Muhammad_khan_Dawar

1 day ago

Bhai it's too much amount, not everyone would be efforts that

@shoaib_1994

1 day ago

your dashboard designing skill is unmatchable... each time I watch your videos on YouTube, I discover something new to learn

·

@Samarth-od4zt

1 day ago

Very Nice brother..!!

·

@kabirpandyaqwe

1 day ago

this is masterpiece gold mine for data professionals

·

@donaldtienzo7799

1 day ago (edited)

Do you have english for this please? You are amazing..

@AhmadRaza-sb6ne

1 day ago (edited)

Love from Pakistan <3

·

@touseefshehbaz170

1 day ago

Started working on it <3

·

@qasimali-gu3oz

1 day ago

You are beyond this world bro.

·

@anandsadhwani7604

1 day ago

Amazing work

·

@AshokKumar_2216

1 day ago

Beautiful Dashboard

·

@The-Developer-BI

2 days ago (edited)

Challenge for you https://youtube.com/shorts/6NIIa-VdSJk?si=Ypv3_CxvjMCpbDI2

Intro

Python Script with Kaggle

Power Query:Setup Tables

Overview Page :DAX,Filters,Visualization

Figma Background Creation

Add Colors,Images,Icons

Athelets Page

Country Page

Historical Page

Paris 2024 Olympics Dashboard Project in PowerBI with Python | The Developer

373Likes

5,023Views

Aug 142024

Get ready to dive into the world of data analytics with a special focus on the Paris 2024 Olympics! 🏅 In this tutorial, we'll guide you through the process of creating a dynamic and visually stunning Power BI dashboard that captures the excitement and data of the Olympic Games. Download from here: https://thedeveloperyt.com/product/ol... 📂Data Source Folder Link- https://drive.google.com/drive/folder... 📚Blogs: How to install Python: https://thedeveloperyt.com/install-py... How to Setup Kaggle with Python https://thedeveloperyt.com/how-to-set... How to Import Olympic Data using Python https://thedeveloperyt.com/olympic-da... 📑Datatset Credit: Name:Petro Dataset Name: Paris 2024 Olympic Summer Games Link:https://www.kaggle.com/datasets/piter... Using a combination of Python, Kaggle datasets, Figma, and other powerful tools, you'll learn how to gather, process, and visualize Olympic data in a way that’s both informative and engaging. Whether you're a data enthusiast, a sports analyst, or a Power BI professional, this project will equip you with the skills to analyze large datasets and present insights that matter. What You Will Learn: Data Extraction with Python: Learn how to use Python to extract and clean data from Kaggle's comprehensive datasets on the Olympics. We'll walk you through the entire process, from accessing the data to preparing it for analysis in Power BI. Designing the Dashboard in Figma: Discover how to design a professional and user-friendly dashboard interface using Figma. We'll cover layout planning, color schemes, and best practices for creating a visually appealing design that enhances the user experience. Building the Dashboard in Power BI: With the data prepared and the design in place, you'll move on to building the dashboard in Power BI. Learn how to create interactive visualizations that track medal counts, athlete performance, event schedules, and more. Advanced Power BI Features: Explore advanced Power BI functionalities, including DAX for complex calculations, Power Query for data transformation, and custom visuals to make your dashboard stand out. Key Topics Covered: Olympic Data Analysis: Understand how to analyze large datasets related to the Paris 2024 Olympics, including athlete statistics, country performance, and historical comparisons. Python Data Processing: Use Python to automate data extraction, cleaning, and preparation for your Power BI dashboard. Figma for Dashboard Design: Master the basics of Figma to create a sleek and modern dashboard design that enhances user interaction. Interactive Visualizations: Create engaging visualizations in Power BI that allow users to explore Olympic data from different angles. Real-Time Data Updates: Learn how to set up your dashboard to automatically update with new data, ensuring that it remains relevant throughout the Olympics. Who Should Watch: Data Analysts & BI Professionals: Take your Power BI skills to the next level by learning how to integrate Python and Figma into your projects. Sports Analysts & Enthusiasts: Get insights into Olympic performance and trends with a customized dashboard tailored to your needs. Students & Beginners: This tutorial is perfect for anyone looking to start their journey into data analytics with a fun and relevant project. Developers: Learn how to combine multiple tools and technologies to create a comprehensive data analysis solution. Why Watch This Video? The Paris 2024 Olympics present a unique opportunity to work with real-world, large-scale data. By the end of this tutorial, you'll have the skills to create a Power BI dashboard that not only looks great but also provides valuable insights into one of the most watched events in the world. Whether you’re preparing for a career in data analytics or just looking to expand your skillset, this project is an excellent way to showcase your abilities. Timestamps: 00:00:00 : Intro 00:06:18 : Python Script with Kaggle 00:18:10 : Power Query:Setup Tables 00:23:53 : Overview Page :DAX,Filters,Visualization 01:01:09 : Figma Background Creation 01:05:15 : Add Colors,Images,Icons 01:26:18 : Athelets Page 01:52:30 : Country Page 01:59:45 : Historical Page Related Keywords: Power BI dashboard Paris 2024 Olympics Python data analysis Kaggle datasets Figma design for dashboards Sports analytics Power BI and Python integration Real-time data in Power BI Advanced Power BI techniques Olympic Games data analysis 🌍Social Media :- Instagram : • / thedevelpoer.yt Linkdin : • / the-developer-407024292 Telegram : • https://www.t.me/thedeveloperyt #powerbi #olympics #parisolympics2024 #python #figma #olympic #powerbitutorialforbeginners #powerbitutorial #powerbidashboarddesign #powerbiproject #powerbitraining#powerbiandpowerquery

Intro

Python Script with Kaggle

Power Query:Setup Tables

Overview Page :DAX,Filters,Visualization

Underground Academy

Hanu Dixit

Underground Academy

Transcript

Follow along using the transcript.

The Developer

15.1K subscribers